package com.alter.service.impl;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Service;

import com.alter.service.DiamInfoService;

@Service
public class DiamInfoServiceImpl implements DiamInfoService {

	@Autowired
	private JdbcTemplate jdbcTemplate;
	
	@Override
	public void createDiamInfo() {
		//INSERT INTO t_diam_info set diam_name='钻石' , diam_price=0.01 , diam_sum=100, give_card=500;
		jdbcTemplate.update("insert into t_diam_info set diamname=? , diamprice=?,id=? ", new Object[] {"钻石", "0.01","2"});
	}

}
